SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Manchester NH Homes page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:BEAUTIFULLY APPOINTED COLONIAL WITH PANORAMIC VIEWS…LIFE IS BETTER ON THE HILL! ! Located in an exclusive north end neighborhood close to schools, shopping and the city’s culinary and cultural offerings, this elegant home captivates from the start. Perched on dramatic multi-level landscaped stone terraces, a covered porch invites you to relax and appreciate sweeping views of land, river and sky. Enter the two story foyer awash in neutral tones accented with crisp white millwork and gleaming wood floors. French doors open to a refined home office ideal for work or study-from-home and opposite a sundrenched dining room will play host to memorable meals and holiday celebrations. You’ll love the open and airy layout of the chef’s kitchen and breakfast area that make the most of backyard views and natural light. The expansive granite island is ideal for quick meals or entertaining in style where lavish buffets and appetizers will take center stage. Enjoy barbecues on the back deck or take the party to the great room where soaring ceilings and a gas fireplace create an inviting ambiance for conversation or marathon movie watching. At day’s end, retreat upstairs to the serene primary offering ensuite bath and walk-in closet to pamper you while three additional bedrooms provide ample space for guests. A partially finished basement offers fabulous storage space and solar panels enhance energy efficiency. EXQUISITE DESIGN AND BREATHTAKING VIEWS…IT’S A PERFECT PLACE TO CALL HOME!
Description:RARE OPPORTUNITY ON THE BANKS OF THE MERRIMACK! YOUR WATERFRONT DREAM NEAR THE CITY HAS ARRIVED! Lovingly cared for and curated over forty years this charming home blends classic vintage details with modern updates. Nestled on a grassy double lot bordered by colorful and manicured perennial gardens you will feel miles away from it all in this most convenient location. As you enter, warm neutral tones and crisp white millwork set the stage. Light-infused spaces and windows framing sparkling water views will captivate you at every turn. Select a favorite book from built-in shelves in the living room and snuggle up to the pellet stove. A gas see-through fireplace creates a lovely ambiance shared with a showstopping dining room ideal for memorable meals. In temperate months throw open French doors to let in warm breezes or take the party outside to a magical flagstone patio for drinks and hors d'oeuvres riverside! Admire the extensive hand-placed granite embankment and dock where you’ll have easy access to swimming and boating. At day’s end savor panoramic sunsets from your favorite front yard chair or from the screened in porch that spans the front of the home. The first floor primary is a welcome sanctuary boasting easy access to the hot tub for soothing soaks while guests delight in two second level bedrooms. A finished living space above the garage is versatile for long-term guests or creative projects. RELAXATION AND BEAUTY BY DESIGN! A TRULY SPECIAL PLACE TO CALL HOME!